Add formulas & functions
Want advanced Google Workspace features for your business?
You can use functions and formulas to automate calculations in Google Sheets.
Tip: If you’re already familiar with functions and formulas and just need to know which ones are available, go to Google Sheets function reference.
[Computer] [Android][iPhone & iPad]
To get an example spreadsheet and follow along with the video, click “Make a Copy” below.
Use a formula​
- Open a spreadsheet.
- Type an equal sign (=) in a cell and type in the function you want to use.
Note: You may see suggested formulas and ranges based on your data.
A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference. If you need more information, click the “Learn more” link at the bottom of the help box to open a full article.
Tip: You might get suggestions to help you complete formulas with the relevant functions. You can accept or reject these suggestions.
To turn formula suggestions on or off, at the top, click Tools 
You might find correction suggestions in previously compiled data and analyses, to improve confidence in insights. You can accept or reject these suggestions.
To turn formula corrections on or off, at the top, click Tools